<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2016/11/2 0002
 * Time: 下午 6:21
 */
header('Content-Type:text/html;charset=utf-8');
echo '<h2>接收到新用户注册！</h2>';
echo '<p>用户名:'.$_POST['username'].'</p>';
echo '<p>密码:'.$_POST['password'].'</p>';
echo  '<p>邮箱:'.$_POST['password'].'</p>';
echo  '<p>IP地址:'.$_SERVER['REMOTE_ADDR'].'</p>';
echo  '<p>浏览器环境:'.$_SERVER['HTTP_USER_AGENT'].'</p>';
echo  '<p>请求来源:'.$_SERVER['HTTP_REFERER'].'</p>';
$username = $_POST['username'];
$password = $_POST['password'];
$email = $_POST['email'];
$link = mysql_connect('localhost','root','123456');
if (!$link){
    die('连接数据库失败！'.mysql_error());
}
mysql_query('set names utf8');
mysql_query('use `itcast`');
$username = mysql_real_escape_string($username);
$email = mysql_real_escape_string($email);
$sql = "select `id` form `user` where `username` ='$username'";
$rst = mysql_query($sql);
if(mysql_fetch_row($rst)){
    die('用户名已经存在，请换个用户名。');
}
$password = md5($password);
$sql = "insert into `user` (`username`, `password`, `email`)VALUES 
                          ('$username','$password','$email')";
$rst = mysql_query($sql);